package com.lagou.service.impl;

import com.lagou.base.StatusCode;
import com.lagou.dao.CourseContentDao;
import com.lagou.dao.impl.CourseContentDaoImpl;
import com.lagou.pojo.Course;
import com.lagou.pojo.Course_Lesson;
import com.lagou.pojo.Course_Section;
import com.lagou.service.CourseContentService;
import com.lagou.utils.DateUtils;
import com.lagou.utils.DruidUtils;
import org.apache.commons.dbutils.QueryRunner;

import java.sql.SQLException;
import java.util.List;

public class CourseContentServiceImpl implements CourseContentService {

    //声明CourseContentDao的引用指向该类的对象，用于调用Dao层的方法
    CourseContentDao contentDao = new CourseContentDaoImpl();

    //展示课程内容
    @Override
    public List<Course_Section> findSectionAndLessonByCourseId(int courseId) {

        List<Course_Section> sections = contentDao.findSectionAndLessonByCourseId(courseId);
        return sections;
    }

    //根据课程ID 回显课程信息
    @Override
    public Course findCourseByCourseId(int courseId) {
        Course course = contentDao.findCourseByCourseId(courseId);

        return course;
    }

    //保存章节信息
    @Override
    public String saveSection(Course_Section section) {
        
        //补全章节信息
        section.setStatus(2);
        String dateFormart = DateUtils.getDateFormart();
        section.setCreate_time(dateFormart);
        section.setUpdate_time(dateFormart);

        //调用dao
        int i = contentDao.saveSection(section);

        //根据是否插入成功封装对应信息
        if(i > 0){
            String result = StatusCode.SUCCESS.toString();
            return result;
        }else {
            String result = StatusCode.FAIL.toString();
            return result;
        }
    }

    //修改章节信息
    @Override
    public String updateSection(Course_Section section) {

        //补全信息
        section.setUpdate_time(DateUtils.getDateFormart());

        //调用dao
        int row = contentDao.updateSection(section);

        //判断是否插入成功
        if(row > 0){
            String result = StatusCode.SUCCESS.toString();
            return result;
        }else {
            String result = StatusCode.FAIL.toString();
            return result;
        }
    }

    //修改章节状态
    @Override
    public String updateSectionStatus(int id, int status) {

        int row = contentDao.updateSectionStatus(id, status);

        //判断是否修改成功
        if(row > 0){
            //修改状态成功
            String result = StatusCode.SUCCESS.toString();
            return result;
        }else {
            //修改失败
            String result = StatusCode.FAIL.toString();
            return result;
        }
    }

    //保存课时信息
    @Override
    public String saveLesson(Course_Lesson lesson) {

        //补全课时信息
        lesson.setStatus(2);
        String dateFormart = DateUtils.getDateFormart();
        lesson.setCreate_time(dateFormart);
        lesson.setUpdate_time(dateFormart);

        //调用dao
        int row = contentDao.saveLesson(lesson);

        //根据是否插入成功封装对应信息
        if(row > 0){
            String result = StatusCode.SUCCESS.toString();
            return result;
        }else {
            String result = StatusCode.FAIL.toString();
            return result;
        }
    }

    //修改课时信息
    @Override
    public String updateLesson(Course_Lesson lesson) {

        //补全修改课时信息
        lesson.setUpdate_time(DateUtils.getDateFormart());

        //调用dao
        int row = contentDao.updateLesson(lesson);

        //根据是否插入成功封装对应信息
        if(row > 0){
            String result = StatusCode.SUCCESS.toString();
            return result;
        }else {
            String result = StatusCode.FAIL.toString();
            return result;
        }
    }

}
